package io.geekidea.boot.overduequery.dto;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.baomidou.mybatisplus.annotation.TableField;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import lombok.NoArgsConstructor;
import lombok.ToString;

import java.awt.*;
import java.io.Serial;
import java.io.Serializable;
import java.time.LocalDateTime;

@Data
@NoArgsConstructor
@ToString(callSuper = true)
@ColumnWidth(value = 15)
public class OverdueQueryExcel implements Serializable {
    @Serial
    private static final long serialVersionUID = 1L;

    @ExcelProperty("入库单号")
    private String storageodd;

    @ExcelProperty("物料编码")
    private String materialcoding;

    @ExcelProperty("物料SN码")
    private String materialsnmark;

    @ExcelProperty("成本价")
    private String costprice;

    @ExcelProperty("合计金额")
    private String totalmoney;

    @ExcelProperty("库存数量")
    private String repertoryquantity;

    @ExcelProperty("库龄")
    private String libraryage;

    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss",timezone="GMT+8",shape = JsonFormat.Shape.STRING)
    @ExcelProperty("入库时间")
    @DateTimeFormat("yyyy-MM-dd")
    private LocalDateTime storageTime;

    @ExcelProperty("战区名称")
    private String areaName;

    @ExcelProperty("门店名称")
    private String storeName;

    @ExcelProperty("超期类型")
    private String rulesName;

    @ExcelProperty("物料仓库")
    private String name;
}
